package auth.ser.usr.repo;

import auth.pub.usr.vo.UsrVO;
import fw.base.core.repo.DefaultMapper;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;

@Mapper
@Repository(value="usrVOMapper")
public interface UsrVOMapper extends DefaultMapper<UsrVO> {

    @Select("select * from sys_bd_usr where usr_code = #{usrCode}")
    public auth.pub.usr.vo.UsrVO findUsrByUsrCode(@Param("usrCode") String usrCode);

    @Select("select * from sys_bd_usr where pk_usr = #{pKUsr}")
    public auth.pub.usr.vo.UsrVO findUsrByPKUsr(@Param("pKUsr") String pKUsr);

    UsrVO getById(String id);
}